DBA Data[Home] [Help]

APPS.ITG_SYNCFIELDINBOUND_PVT dependencies on ITG_DEBUG

Line 29: itg_debug_pub.Add('ENTERING PPN-Process_PoNumber',2);

25: /* Initialize return status */
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27:
28: IF (l_Debug_Level <= 2) THEN
29: itg_debug_pub.Add('ENTERING PPN-Process_PoNumber',2);
30: END IF;
31:
32: BEGIN
33: SAVEPOINT Process_PoNumber_PVT;

Line 43: ITG_Debug.setup(

39: itg_msg.invalid_org(p_org);
40: RAISE FND_API.G_EXC_ERROR;
41: END;
42:
43: ITG_Debug.setup(
44: p_reset => TRUE,
45: p_pkg_name => G_PKG_NAME,
46: p_proc_name => l_api_name);
47:

Line 51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);

47:
48: --Now in wrapper
49: --FND_MSG_PUB.Initialize;
50: IF (l_Debug_Level <= 1) THEN
51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);

Line 52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);

48: --Now in wrapper
49: --FND_MSG_PUB.Initialize;
50: IF (l_Debug_Level <= 1) THEN
51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);
56: END IF;

Line 53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);

49: --FND_MSG_PUB.Initialize;
50: IF (l_Debug_Level <= 1) THEN
51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);
56: END IF;
57:

Line 54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);

50: IF (l_Debug_Level <= 1) THEN
51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);
56: END IF;
57:
58: g_action := 'Sync-field parameter validation';

Line 55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);

51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);
56: END IF;
57:
58: g_action := 'Sync-field parameter validation';
59:

Line 61: itg_debug_pub.Add('PPN - Validating inputs' ,1);

57:
58: g_action := 'Sync-field parameter validation';
59:
60: IF (l_Debug_Level <= 1) THEN
61: itg_debug_pub.Add('PPN - Validating inputs' ,1);
62: END IF;
63:
64: ITG_BOAPI_Utils.validate('FIELDID', NULL, NULL, FALSE, p_reqid);
65: ITG_BOAPI_Utils.validate('ORACLEITG.REQLINENUM', NULL, NULL, FALSE, p_reqlinenum);

Line 70: itg_debug_pub.Add('PPN - Updating requisition info' ,1);

66: ITG_BOAPI_Utils.validate('ORACLEITG.POID', NULL, NULL, FALSE, p_poid);
67: ITG_BOAPI_Utils.validate('ORACLEITG.POENTITY', NULL, NULL, FALSE, p_org);
68:
69: IF (l_Debug_Level <= 1) THEN
70: itg_debug_pub.Add('PPN - Updating requisition info' ,1);
71: END IF;
72: /* 2683558 : multiple po numbers from SAP for the same Req. Updates the table
73: with "," seperated. */
74:

Line 96: itg_debug_pub.Add('PPN - Update done' ,1);

92: WHERE requisition_header_id = l_req_hdr_id
93: AND line_num = p_reqlinenum;
94:
95: IF (l_Debug_Level <= 1) THEN
96: itg_debug_pub.Add('PPN - Update done' ,1);
97: END IF;
98:
99: IF SQL%ROWCOUNT <> 1 THEN
100: IF (l_Debug_Level <= 1) THEN

Line 101: itg_debug_pub.Add('PPN - Update failed' ,1);

97: END IF;
98:
99: IF SQL%ROWCOUNT <> 1 THEN
100: IF (l_Debug_Level <= 1) THEN
101: itg_debug_pub.Add('PPN - Update failed' ,1);
102: END IF;
103:
104: ITG_MSG.no_req_line(p_reqid, p_reqlinenum,p_org);
105: RAISE FND_API.G_EXC_ERROR;

Line 118: itg_debug.msg('Unexpected error (Field sync) - ' || substr(SQLERRM,1,255),true);

114:
115: WHEN OTHERS THEN
116: ROLLBACK TO Process_PoNumber_PVT;
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118: itg_debug.msg('Unexpected error (Field sync) - ' || substr(SQLERRM,1,255),true);
119: ITG_msg.unexpected_error(g_action);
120: END;
121:
122: IF (l_Debug_Level <= 2) THEN

Line 123: itg_debug_pub.Add('EXITING PPN-Process_PoNumber',2);

119: ITG_msg.unexpected_error(g_action);
120: END;
121:
122: IF (l_Debug_Level <= 2) THEN
123: itg_debug_pub.Add('EXITING PPN-Process_PoNumber',2);
124: END IF;
125:
126: --Removed FND_MSG_PUB.Count_And_Get
127: END Process_PoNumber;